export interface Connection {
  id: string
  name: string
  host: string
  port: number
  username: string
  database_name?: string
  description?: string
  is_active: boolean
  created_at: string
  updated_at: string
  last_used_at?: string
}

export interface CreateConnectionData {
  name: string
  host: string
  port: number
  username: string
  password: string
  database_name?: string
  description?: string
}

export interface UpdateConnectionData {
  name?: string
  host?: string
  port?: number
  username?: string
  password?: string
  database_name?: string
  description?: string
  is_active?: boolean
}

export interface ConnectionTestResult {
  success: boolean
  message: string
  databases?: string[]
  response_time?: number
}

export interface DatabaseSchema {
  database: string
  tables: Array<{
    name: string
    columns: Array<{
      name: string
      type: string
      nullable: boolean
      default?: string
      comment?: string
    }>
  }>
}